10. Curing Bobby Tables

Curing Bobby Tables - Intro to Relational Databases

At the end, the video says to press "Submit". That's for an older version of this quiz. Instead, just complete this checklist —

Task Description:

Update the forum code to be safe against the SQL injection attack. Check your work by writing forum posts that contain single quotes. Also check that the attack message doesn't delete the forum any more.

Task List:

Task Feedback:

Great! Take a look at the next video for one way to do this.

Solution:

Ud197 RDB REDO L3 11S Curing Bobby Tables SOLUTION

By the way, the warnings about using % with SQL statements and user data also apply to newer ways of doing string formatting in Python. This includes f-strings, introduced in Python 3.6.